Find-Records names a function, with lambda list (TYPE &REST COLUMNS+VALUES):
Find all records of TYPE where each of COLUMNS+VALUES are exact matches.
For each of the columns named, the value given must be an exact match. In the case of SQL, this translates neatly into a construction such as “WHERE column₁ = value₁, AND column₂ = value₂, … AND columnｎ = valueｎ.” With other kinds of database (e.g. LDAP, Couch, &c) the equivalent constructions will be used.
This method is not suitable for inequalities, set comparisons, or the like — in fact, only value-like equality is supported.
The function returns NIL if no records are found.
Defined in file src/db/generic-db.lisp.